// var express = require('express');
import express from "express";
var app = express();
import mysql from "mysql";
//连接数据库
var connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password : 'root',
    database : 'tackout'
});
connection.connect();
//设置跨域访问
app.all('*', function(req, res, next) {
    res.header("Access-Control-Allow-Origin", "*");
    res.header("Access-Control-Allow-Headers", "X-Requested-With");
    res.header("Access-Control-Allow-Methods","PUT,POST,GET,DELETE,OPTIONS");
    res.header("X-Powered-By",' 3.2.1');
    res.header("Content-Type", "application/json;charset=utf-8");
    next();
});
var result = {
    "status": "200",
    "message": "success",
}
connection.query('select * from admin', function(err, rows, fields) {
    if (err) throw err;
    return  result.data=rows;
});
connection.end();
//getAdminList
app.get('/getAdminList',function(req,res){
    res.status(200),
        res.json(result)
});
//配置服务端口
var server = app.listen(3000, function () {
    var host = server.address().host;
    console.log(host)
    var port = server.address().port;
    console.log(port)
    console.log('Example app listening at http://localhost:'+port);
})

